import xlrd
class LoginData4:
    da = xlrd.open_workbook(filename="自动化.xlsx")
    st = da.sheet_by_index(3)
    # 获取多少行，多少列数据
    nrows = st.nrows
    param = []
    for i in range(1, nrows):
        l = []
        for j in range(0, 4):
            l.append(st.row_values(i)[j])
        param.append(l)
        print(param)
class LoginData5:
    da = xlrd.open_workbook(filename="自动化.xlsx")
    st = da.sheet_by_index(4)
    # 获取多少行，多少列数据
    nrows = st.nrows
    param = []
    for i in range(1, nrows):
        l = []
        for j in range(0, 4):
            l.append(st.row_values(i)[j])
        param.append(l)
        print(param)
class LoginData6:
    da = xlrd.open_workbook(filename="自动化.xlsx")
    st = da.sheet_by_index(5)
    # 获取多少行，多少列数据
    nrows = st.nrows
    param = []
    for i in range(1, nrows):
        l = []
        for j in range(0, 7):
            l.append(st.row_values(i)[j])
        param.append(l)
        print(param)
class LoginData7:
    da = xlrd.open_workbook(filename="自动化.xlsx")
    st = da.sheet_by_index(6)
    # 获取多少行，多少列数据
    nrows = st.nrows
    param = []
    for i in range(1, nrows):
        l = []
        for j in range(0, 5):
            l.append(st.row_values(i)[j])
        param.append(l)
        print(param)
class LoginData8:
    da = xlrd.open_workbook(filename="自动化.xlsx")
    st = da.sheet_by_index(7)
    # 获取多少行，多少列数据
    nrows = st.nrows
    param = []
    for i in range(1, nrows):
        l = []
        for j in range(0, 5):
            l.append(st.row_values(i)[j])
        param.append(l)
        print(param)
class LoginData9:
    da = xlrd.open_workbook(filename="自动化.xlsx")
    st = da.sheet_by_index(3)
    # 获取多少行，多少列数据
    nrows = st.nrows
    param = []
    for i in range(1, nrows):
        l = []
        for j in range(0, 4):
            l.append(st.row_values(i)[j])
        param.append(l)
        print(param)
class LoginData10:
    da = xlrd.open_workbook(filename="自动化.xlsx")
    st = da.sheet_by_index(4)
    # 获取多少行，多少列数据
    nrows = st.nrows
    param = []
    for i in range(1, nrows):
        l = []
        for j in range(0, 4):
            l.append(st.row_values(i)[j])
        param.append(l)
        print(param)
class LoginData11:
    da = xlrd.open_workbook(filename="自动化.xlsx")
    st = da.sheet_by_index(3)
    # 获取多少行，多少列数据
    nrows = st.nrows
    param = []
    for i in range(1, nrows):
        l = []
        for j in range(0, 4):
            l.append(st.row_values(i)[j])
        param.append(l)
        print(param)
class LoginData12:
    da = xlrd.open_workbook(filename="自动化.xlsx")
    st = da.sheet_by_index(4)
    # 获取多少行，多少列数据
    nrows = st.nrows
    param = []
    for i in range(1, nrows):
        l = []
        for j in range(0, 4):
            l.append(st.row_values(i)[j])
        param.append(l)
        print(param)
class LoginData13:
    da = xlrd.open_workbook(filename="自动化.xlsx")
    st = da.sheet_by_index(8)
    # 获取多少行，多少列数据
    nrows = st.nrows
    param = []
    for i in range(1, nrows):
        l = []
        for j in range(0, 5):
            l.append(st.row_values(i)[j])
        param.append(l)
        print(param)